package com.lottery.game.core.modules.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.lottery.game.core.modules.entity.user.CustomerService;
import com.lottery.game.core.modules.entity.user.GameCustomerNotice;

public interface KfglDao {
	
	
	@Select("SELECT * FROM customer_service t where t.statuss =0 ")
	public List<CustomerService> getAllKf();
	
	@Select("SELECT * FROM game_customer_notice where status=0 ORDER BY updateTime DESC ,STATUS DESC ")
	public List<GameCustomerNotice> getAllKfGg();
	
	@Select("SELECT count(*) FROM customer_service")
	int selectCount();

	@Select("SELECT * FROM game_customer_notice where status=0 and title like CONCAT('%',#{title},'%') ORDER BY updateTime DESC ,STATUS DESC")
	public List<GameCustomerNotice> getKftitleByLike(@Param("title")String title);
 
}
